From 200fe59bfc2f891a15e194f4d152b74fe20c938b Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 18 Jul 2026 00:48:27 +0000 Subject: [PATCH] Create, document, index, and trigger ELO_RANKS_DAILY_MT_F --- db/schemas/lib/triggers/Makefile | 3 ++- .../triggers/create/elo_ranks_daily_mt_f.m4 | 27 +++++++++++++++++++ .../lib/triggers/drop/elo_ranks_daily_mt_f.m4 | 24 +++++++++++++++++ db/schemas/sokwedb/indexes/Makefile | 3 ++- .../indexes/create/elo_ranks_daily_mt_f.m4 | 24 +++++++++++++++++ .../indexes/drop/elo_ranks_daily_mt_f.m4 | 24 +++++++++++++++++ db/schemas/sokwedb/tables/Makefile | 4 ++- .../tables/create/elo_ranks_daily_mt_f.m4 | 26 ++++++++++++++++++ doc/src/analyzed.m4 | 1 + doc/src/analyzed/elo_ranks_daily_mt_f.m4 | 22 +++++++++++++++ doc/src/epilog.inc.m4 | 3 +++ 11 files changed, 158 insertions(+), 3 deletions(-) create mode 100644 db/schemas/lib/triggers/create/elo_ranks_daily_mt_f.m4 create mode 100644 db/schemas/lib/triggers/drop/elo_ranks_daily_mt_f.m4 create mode 100644 db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_f.m4 create mode 100644 db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_f.m4 create mode 100644 db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_f.m4 create mode 100644 doc/src/analyzed/elo_ranks_daily_mt_f.m4 diff --git a/db/schemas/lib/triggers/Makefile b/db/schemas/lib/triggers/Makefile index 9ff08f6..1c365dd 100644 --- a/db/schemas/lib/triggers/Makefile +++ b/db/schemas/lib/triggers/Makefile @@ -52,7 +52,8 @@ ORDER := comm_ids \ brecord_notes \ colobus \ matings \ - elo_ranks_daily_kk_f + elo_ranks_daily_kk_f \ + elo_ranks_daily_mt_f DROP_EXISTING := true diff --git a/db/schemas/lib/triggers/create/elo_ranks_daily_mt_f.m4 b/db/schemas/lib/triggers/create/elo_ranks_daily_mt_f.m4 new file mode 100644 index 0000000..aa98b7d --- /dev/null +++ b/db/schemas/lib/triggers/create/elo_ranks_daily_mt_f.m4 @@ -0,0 +1,27 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify it +dnl under the terms of the GNU Affero General Public License as published by +dnl the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Triggers for the elo_ranks_daily_mt_f table +dnl +dnl Karl O. Pinc + +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`macros.m4')dnl +include(`elo_ranks_daily_triggers_create.m4')dnl + + +elo_ranks_daily_triggers_create(`female', sdb_female, `MT') diff --git a/db/schemas/lib/triggers/drop/elo_ranks_daily_mt_f.m4 b/db/schemas/lib/triggers/drop/elo_ranks_daily_mt_f.m4 new file mode 100644 index 0000000..3c80c59 --- /dev/null +++ b/db/schemas/lib/triggers/drop/elo_ranks_daily_mt_f.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc. http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published by +dnl the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Drop triggers for elo_ranks_daily_mt_f table +dnl +dnl Karl O. Pinc + +dnl m4 includes +include(`copyright.m4')dnl +include(`elo_ranks_daily_triggers_drop.m4')dnl + +elo_ranks_daily_triggers_drop(sdb_female, `MT') diff --git a/db/schemas/sokwedb/indexes/Makefile b/db/schemas/sokwedb/indexes/Makefile index 11c23ec..9646662 100644 --- a/db/schemas/sokwedb/indexes/Makefile +++ b/db/schemas/sokwedb/indexes/Makefile @@ -24,7 +24,8 @@ ORDER := biography_data biography_log comm_membs comm_memb_log \ swelling_sources swelling_states aggression_event_log sightings \ aggressions food_events groomings attendance \ arrivals_a species_present repro_states locations_utm \ - locations_paper colobus matings fertility elo_ranks_daily_kk_f + locations_paper colobus matings fertility elo_ranks_daily_kk_f \ + elo_ranks_daily_mt_f ## ## CAUTION: This Makefile is not designed to be run directly. It is normally diff --git a/db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_f.m4 b/db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_f.m4 new file mode 100644 index 0000000..6ea1ab8 --- /dev/null +++ b/db/schemas/sokwedb/indexes/create/elo_ranks_daily_mt_f.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`indexmacros.m4')dnl + +elo_ranks_daily_indexes_create(sdb_female, `MT') diff --git a/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_f.m4 b/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_f.m4 new file mode 100644 index 0000000..841dd0f --- /dev/null +++ b/db/schemas/sokwedb/indexes/drop/elo_ranks_daily_mt_f.m4 @@ -0,0 +1,24 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`indexmacros.m4')dnl + +elo_ranks_daily_indexes_drop(sdb_female, `MT') diff --git a/db/schemas/sokwedb/tables/Makefile b/db/schemas/sokwedb/tables/Makefile index 60d9253..7b81e5b 100644 --- a/db/schemas/sokwedb/tables/Makefile +++ b/db/schemas/sokwedb/tables/Makefile @@ -51,7 +51,9 @@ ORDER := biography_data \ colobus \ matings \ fertility \ - elo_ranks_daily_kk_f + elo_ranks_daily_kk_f \ + elo_ranks_daily_mt_f + ## ## CAUTION: This Makefile is not designed to be run directly. It is normally ## invoked by another Makefile. diff --git a/db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_f.m4 b/db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_f.m4 new file mode 100644 index 0000000..4969a4e --- /dev/null +++ b/db/schemas/sokwedb/tables/create/elo_ranks_daily_mt_f.m4 @@ -0,0 +1,26 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`tablemacros.m4')dnl +include(`grants.m4')dnl +dnl + +elo_ranks_daily_table(sdb_female, `MT') diff --git a/doc/src/analyzed.m4 b/doc/src/analyzed.m4 index 4b17bab..a8bd791 100644 --- a/doc/src/analyzed.m4 +++ b/doc/src/analyzed.m4 @@ -32,6 +32,7 @@ a rudimentary analytical process. :maxdepth: 3 analyzed/elo_ranks_daily_kk_f.rst + analyzed/elo_ranks_daily_mt_f.rst analyzed/fertility.rst analyzed/repro_states.rst analyzed/swelling_states.rst diff --git a/doc/src/analyzed/elo_ranks_daily_mt_f.m4 b/doc/src/analyzed/elo_ranks_daily_mt_f.m4 new file mode 100644 index 0000000..8e764e1 --- /dev/null +++ b/doc/src/analyzed/elo_ranks_daily_mt_f.m4 @@ -0,0 +1,22 @@ +.. Copyright (C) 2026 The Meme Factory, Inc. www.karlpinc.com + + This program is free software: you can redistribute it and/or modify + it under the terms of the GNU Affero General Public License as + published by the Free Software Foundation, either version 3 of the + License, or (at your option) any later version. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU Affero General Public License for more details. + + You should have received a copy of the GNU Affero General Public License + along with this program. If not, see . + +.. M4 setup +include(constants.m4)dnl +include(macros.m4)dnl +include(elo_ranks_daily_macro.m4)dnl +sdb_generated_rst()dnl + +elo_ranks_daily_macro(female, sdb_female, MT) diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index dd63caa..83d381e 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -396,6 +396,9 @@ sdb_generated_rst()dnl .. ELO_RANKS_DAILY_KK_F elo_ranks_daily_rst(sdb_female, KK)dnl +.. ELO_RANKS_DAILY_MT_F +elo_ranks_daily_rst(sdb_female, MT)dnl + .. |ENTRYTYPES| replace:: :ref:`ENTRYTYPES ` .. |ENTRYTYPES.EntryType| replace:: :ref:`EntryType ` -- 2.34.1